package net.esj.basic.utils;

import java.util.HashMap;
import java.util.Map;

@Deprecated
public class SQLUtils {
	
	public static final String SQL_STATE_EQUAL = "eq";
	public static final String SQL_STATE_IN = "in";
	public static final String SQL_STATE_LIKE = "lk";
	public static final String SQL_STATE_NOT = "nt";
	public static final String SQL_STATE_GRATER = "gt";
	public static final String SQL_STATE_LESS = "lt";
	public static final String SQL_STATE_GRATER_AND_EQUAL = "ge";
	public static final String SQL_STATE_LESS_AND_EQUAL = "le";
	public static final String SQL_STATE_ORDERBY = "order";
	public static final String SQL_STATE_ORDER_ASC = "asc";
	public static final String SQL_STATE_ORDER_DESC= "desc";
	public static final String SQL_STATE_GROUPBY = "groupby";
	public static final String SQL_STATE_FETCH = "fetch";
	
	public static final String HQL_FETCH_JOIN = "join";
	public static final String HQL_FETCH_SELECT = "select";
	public static final String HQL_FETCH_EAGER = "eager";
	public static final String HQL_FETCH_LAZY = "lazy";
	
	public static Map<String,Object> generateQuery(String[] keys ,Object[] values){
		Map<String,Object> query = new HashMap<String, Object>();
		int i=0;
		for(String str : keys){
			query.put(str, values[i]);
			i++;
		}
		return query;
	}
} 
